My Dataset Profile

Brought to you by YData

Dataset statistics

Number of variables	19
Number of observations	170653
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	24.7 MiB
Average record size in memory	152.0 B

Variable types

Numeric	13
Text	3
Categorical	2
DateTime	1

Alerts

`acousticness` is highly overall correlated with `energy` and 3 other fields	High correlation
`danceability` is highly overall correlated with `valence`	High correlation
`energy` is highly overall correlated with `acousticness` and 2 other fields	High correlation
`loudness` is highly overall correlated with `acousticness` and 3 other fields	High correlation
`popularity` is highly overall correlated with `acousticness` and 2 other fields	High correlation
`valence` is highly overall correlated with `danceability`	High correlation
`year` is highly overall correlated with `acousticness` and 3 other fields	High correlation
`explicit` is highly imbalanced (58.2%)	Imbalance
`id` has unique values	Unique
`instrumentalness` has 46580 (27.3%) zeros	Zeros
`key` has 21600 (12.7%) zeros	Zeros
`popularity` has 27892 (16.3%) zeros	Zeros

Reproduction

Analysis started	2025-09-26 23:16:04.202847
Analysis finished	2025-09-26 23:16:40.743768
Duration	36.54 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

valence
Real number (ℝ)

High correlation

Distinct	1733
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.52858721

Minimum	0
Maximum	1
Zeros	196
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0905
Q1	0.317
median	0.54
Q3	0.747
95-th percentile	0.937
Maximum	1
Range	1
Interquartile range (IQR)	0.43

Descriptive statistics

Standard deviation	0.26317146
Coefficient of variation (CV)	0.49787709
Kurtosis	-1.0616275
Mean	0.52858721
Median Absolute Deviation (MAD)	0.215
Skewness	-0.10711976
Sum	90204.993
Variance	0.069259219
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.961	718	0.4%
0.962	593	0.3%
0.963	515	0.3%
0.964	462	0.3%
0.965	400	0.2%
0.96	388	0.2%
0.966	349	0.2%
0.967	316	0.2%
0.968	269	0.2%
0.559	248	0.1%
Other values (1723)	166395	97.5%

Value	Count	Frequency (%)
0	196	0.1%
1 × 10^-5	70	< 0.1%
6.41 × 10^-5	1	< 0.1%
0.000537	1	< 0.1%
0.000562	1	< 0.1%
0.00126	1	< 0.1%
0.00166	1	< 0.1%
0.00173	1	< 0.1%
0.00213	1	< 0.1%
0.00228	1	< 0.1%

Value	Count	Frequency (%)
1	4	< 0.1%
0.998	1	< 0.1%
0.996	2	< 0.1%
0.995	1	< 0.1%
0.994	3	< 0.1%
0.993	4	< 0.1%
0.991	4	< 0.1%
0.99	8	< 0.1%
0.989	6	< 0.1%
0.988	7	< 0.1%

year
Real number (ℝ)

High correlation

Distinct	100
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1976.7872

Minimum	1921
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1921
5-th percentile	1933
Q1	1956
median	1977
Q3	1999
95-th percentile	2016
Maximum	2020
Range	99
Interquartile range (IQR)	43

Descriptive statistics

Standard deviation	25.917853
Coefficient of variation (CV)	0.013111099
Kurtosis	-1.0355084
Mean	1976.7872
Median Absolute Deviation (MAD)	22
Skewness	-0.12943464
Sum	3.3734467 × 10⁸
Variance	671.73508
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2018	2103	1.2%
2020	2030	1.2%
2011	2017	1.2%
2010	2016	1.2%
2001	2005	1.2%
2014	2005	1.2%
1949	2000	1.2%
1955	2000	1.2%
1954	2000	1.2%
1978	2000	1.2%
Other values (90)	150477	88.2%

Value	Count	Frequency (%)
1921	150	0.1%
1922	71	< 0.1%
1923	185	0.1%
1924	236	0.1%
1925	278	0.2%
1926	1378	0.8%
1927	615	0.4%
1928	1261	0.7%
1929	952	0.6%
1930	1924	1.1%

Value	Count	Frequency (%)
2020	2030	1.2%
2019	1949	1.1%
2018	2103	1.2%
2017	1992	1.2%
2016	1797	1.1%
2015	1974	1.2%
2014	2005	1.2%
2013	1976	1.2%
2012	1945	1.1%
2011	2017	1.2%

acousticness
Real number (ℝ)

High correlation

Distinct	4689
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.50211476

Minimum	0
Maximum	0.996
Zeros	20
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.00147
Q1	0.102
median	0.516
Q3	0.893
95-th percentile	0.992
Maximum	0.996
Range	0.996
Interquartile range (IQR)	0.791

Descriptive statistics

Standard deviation	0.37603173
Coefficient of variation (CV)	0.74889597
Kurtosis	-1.6094281
Mean	0.50211476
Median Absolute Deviation (MAD)	0.395
Skewness	-0.032582418
Sum	85687.391
Variance	0.14139986
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.995	3117	1.8%
0.994	2323	1.4%
0.993	1759	1.0%
0.992	1513	0.9%
0.991	1298	0.8%
0.99	1180	0.7%
0.996	1058	0.6%
0.989	1053	0.6%
0.988	927	0.5%
0.987	818	0.5%
Other values (4679)	155607	91.2%

Value	Count	Frequency (%)
0	20	< 0.1%
1 × 10^-6	1	< 0.1%
1.01 × 10^-6	3	< 0.1%
1.02 × 10^-6	1	< 0.1%
1.03 × 10^-6	1	< 0.1%
1.05 × 10^-6	2	< 0.1%
1.07 × 10^-6	1	< 0.1%
1.11 × 10^-6	1	< 0.1%
1.15 × 10^-6	1	< 0.1%
1.17 × 10^-6	2	< 0.1%

Value	Count	Frequency (%)
0.996	1058	0.6%
0.995	3117	1.8%
0.994	2323	1.4%
0.993	1759	1.0%
0.992	1513	0.9%
0.991	1298	0.8%
0.99	1180	0.7%
0.989	1053	0.6%
0.988	927	0.5%
0.987	818	0.5%

artists
Text

Distinct	34088
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Length

Max length	661
Median length	345
Mean length	23.369282
Min length	5

Characters and Unicode

Total characters	3988038
Distinct characters	613
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20168 ?
Unique (%)	11.8%

Sample

1st row	['Sergei Rachmaninoff', 'James Levine', 'Berliner Philharmoniker']
2nd row	['Dennis Day']
3rd row	['KHP Kridhamardawa Karaton Ngayogyakarta Hadiningrat']
4th row	['Frank Parker']
5th row	['Phil Regan']

Value	Count	Frequency (%)
the	17347	3.5%
orchestra	6068	1.2%
	5771	1.2%
john	2491	0.5%
francisco	2357	0.5%
canaro	2253	0.5%
los	2034	0.4%
de	1928	0.4%
his	1784	0.4%
of	1732	0.4%
Other values (25904)	450708	91.1%

Most occurring characters

Value	Count	Frequency (%)
'	450922	11.3%
	323820	8.1%
e	264139	6.6%
a	252534	6.3%
r	193143	4.8%
n	188862	4.7%
i	186004	4.7%
o	179597	4.5%
]	170658	4.3%
[	170658	4.3%
Other values (603)	1607701	40.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3988038	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
'	450922	11.3%
	323820	8.1%
e	264139	6.6%
a	252534	6.3%
r	193143	4.8%
n	188862	4.7%
i	186004	4.7%
o	179597	4.5%
]	170658	4.3%
[	170658	4.3%
Other values (603)	1607701	40.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3988038	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
'	450922	11.3%
	323820	8.1%
e	264139	6.6%
a	252534	6.3%
r	193143	4.8%
n	188862	4.7%
i	186004	4.7%
o	179597	4.5%
]	170658	4.3%
[	170658	4.3%
Other values (603)	1607701	40.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3988038	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
'	450922	11.3%
	323820	8.1%
e	264139	6.6%
a	252534	6.3%
r	193143	4.8%
n	188862	4.7%
i	186004	4.7%
o	179597	4.5%
]	170658	4.3%
[	170658	4.3%
Other values (603)	1607701	40.3%

danceability
Real number (ℝ)

High correlation

Distinct	1240
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.53739553

Minimum	0
Maximum	0.988
Zeros	143
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.23
Q1	0.415
median	0.548
Q3	0.668
95-th percentile	0.811
Maximum	0.988
Range	0.988
Interquartile range (IQR)	0.253

Descriptive statistics

Standard deviation	0.17613774
Coefficient of variation (CV)	0.32776181
Kurtosis	-0.44289742
Mean	0.53739553
Median Absolute Deviation (MAD)	0.126
Skewness	-0.22347135
Sum	91708.16
Variance	0.031024502
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.565	430	0.3%
0.612	408	0.2%
0.632	402	0.2%
0.61	401	0.2%
0.578	399	0.2%
0.559	398	0.2%
0.545	397	0.2%
0.6	395	0.2%
0.548	394	0.2%
0.556	393	0.2%
Other values (1230)	166636	97.6%

Value	Count	Frequency (%)
0	143	0.1%
0.0551	1	< 0.1%
0.0559	2	< 0.1%
0.0569	2	< 0.1%
0.0574	1	< 0.1%
0.0583	1	< 0.1%
0.0587	1	< 0.1%
0.0589	1	< 0.1%
0.059	1	< 0.1%
0.0591	1	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.986	2	< 0.1%
0.985	1	< 0.1%
0.983	1	< 0.1%
0.98	4	< 0.1%
0.979	3	< 0.1%
0.978	3	< 0.1%
0.977	5	< 0.1%
0.976	1	< 0.1%
0.975	6	< 0.1%

duration_ms
Real number (ℝ)

Distinct	51755
Distinct (%)	30.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	230948.31

Minimum	5108
Maximum	5403500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	5108
5-th percentile	110987
Q1	169827
median	207467
Q3	262400
95-th percentile	411551.6
Maximum	5403500
Range	5398392
Interquartile range (IQR)	92573

Descriptive statistics

Standard deviation	126118.41
Coefficient of variation (CV)	0.54608936
Kurtosis	132.92182
Mean	230948.31
Median Absolute Deviation (MAD)	44467
Skewness	7.3137407
Sum	3.9412022 × 10¹⁰
Variance	1.5905855 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
192000	56	< 0.1%
170000	50	< 0.1%
180000	49	< 0.1%
186000	49	< 0.1%
160000	48	< 0.1%
184000	48	< 0.1%
240000	46	< 0.1%
168000	46	< 0.1%
195000	45	< 0.1%
175000	44	< 0.1%
Other values (51745)	170172	99.7%

Value	Count	Frequency (%)
5108	1	< 0.1%
5991	1	< 0.1%
6362	1	< 0.1%
6467	1	< 0.1%
8853	2	< 0.1%
9680	1	< 0.1%
10371	1	< 0.1%
11973	1	< 0.1%
13453	1	< 0.1%
13600	1	< 0.1%

Value	Count	Frequency (%)
5403500	1	< 0.1%
4270034	1	< 0.1%
4269407	1	< 0.1%
4120258	2	< 0.1%
3816373	1	< 0.1%
3650800	1	< 0.1%
3569933	1	< 0.1%
3557955	1	< 0.1%
3556867	1	< 0.1%
3551152	1	< 0.1%

energy
Real number (ℝ)

High correlation

Distinct	2332
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.48238884

Minimum	0
Maximum	1
Zeros	9
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.076
Q1	0.255
median	0.471
Q3	0.703
95-th percentile	0.924
Maximum	1
Range	1
Interquartile range (IQR)	0.448

Descriptive statistics

Standard deviation	0.2676457
Coefficient of variation (CV)	0.55483395
Kurtosis	-1.1001327
Mean	0.48238884
Median Absolute Deviation (MAD)	0.224
Skewness	0.11203494
Sum	82321.102
Variance	0.071634223
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.2	247	0.1%
0.341	244	0.1%
0.187	242	0.1%
0.255	241	0.1%
0.219	239	0.1%
0.274	238	0.1%
0.185	238	0.1%
0.245	237	0.1%
0.306	237	0.1%
0.32	237	0.1%
Other values (2322)	168253	98.6%

Value	Count	Frequency (%)
0	9	< 0.1%
1.99 × 10^-5	1	< 0.1%
2 × 10^-5	1	< 0.1%
2.01 × 10^-5	7	< 0.1%
2.02 × 10^-5	3	< 0.1%
2.03 × 10^-5	10	< 0.1%
2.8 × 10^-5	1	< 0.1%
3.22 × 10^-5	1	< 0.1%
4.28 × 10^-5	1	< 0.1%
4.98 × 10^-5	1	< 0.1%

Value	Count	Frequency (%)
1	21	< 0.1%
0.999	28	< 0.1%
0.998	38	< 0.1%
0.997	51	< 0.1%
0.996	64	< 0.1%
0.995	81	< 0.1%
0.994	76	< 0.1%
0.993	73	< 0.1%
0.992	59	< 0.1%
0.991	88	0.1%

explicit
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	156220
1	14433

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	170653
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

Most occurring characters

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	170653	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	170653	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	170653	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

id
Text

Unique

Distinct	170653
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	3754366
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	170653 ?
Unique (%)	100.0%

Sample

1st row	4BJqT0PrAfrxzMOxytFOIz
2nd row	7xPhfUan2yNtyFG0cUWkt8
3rd row	1o6I8BglA6ylDMrIELygv1
4th row	3ftBPsC5vPBKxYSee08FDH
5th row	4d6HGyGT8e121BsdKmw9v6

Value	Count	Frequency (%)
0lcxzabea84egudqpnun1i	1	< 0.1%
7hmnjhfs0bkfzx4x8j0hkl	1	< 0.1%
4bjqt0prafrxzmoxytfoiz	1	< 0.1%
7xphfuan2yntyfg0cuwkt8	1	< 0.1%
1o6i8bgla6yldmrielygv1	1	< 0.1%
3ftbpsc5vpbkxysee08fdh	1	< 0.1%
4d6hgygt8e121bsdkmw9v6	1	< 0.1%
4pyw9dvhgsture4j6hpngr	1	< 0.1%
5unznelqos3w4frmrypk4t	1	< 0.1%
02gdntoxexbfuvsgaxlpkd	1	< 0.1%
Other values (170643)	170643	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	82448	2.2%
1	81401	2.2%
2	80500	2.1%
3	79581	2.1%
4	78941	2.1%
5	78481	2.1%
6	77828	2.1%
7	73852	2.0%
L	58509	1.6%
t	58331	1.6%
Other values (52)	3004494	80.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3754366	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	82448	2.2%
1	81401	2.2%
2	80500	2.1%
3	79581	2.1%
4	78941	2.1%
5	78481	2.1%
6	77828	2.1%
7	73852	2.0%
L	58509	1.6%
t	58331	1.6%
Other values (52)	3004494	80.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3754366	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	82448	2.2%
1	81401	2.2%
2	80500	2.1%
3	79581	2.1%
4	78941	2.1%
5	78481	2.1%
6	77828	2.1%
7	73852	2.0%
L	58509	1.6%
t	58331	1.6%
Other values (52)	3004494	80.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3754366	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	82448	2.2%
1	81401	2.2%
2	80500	2.1%
3	79581	2.1%
4	78941	2.1%
5	78481	2.1%
6	77828	2.1%
7	73852	2.0%
L	58509	1.6%
t	58331	1.6%
Other values (52)	3004494	80.0%

instrumentalness
Real number (ℝ)

Zeros

Distinct	5401
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.16700958

Minimum	0
Maximum	1
Zeros	46580
Zeros (%)	27.3%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.000216
Q3	0.102
95-th percentile	0.905
Maximum	1
Range	1
Interquartile range (IQR)	0.102

Descriptive statistics

Standard deviation	0.31347467
Coefficient of variation (CV)	1.8769862
Kurtosis	0.94219542
Mean	0.16700958
Median Absolute Deviation (MAD)	0.000216
Skewness	1.631114
Sum	28500.686
Variance	0.098266371
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	46580	27.3%
0.916	201	0.1%
0.917	197	0.1%
0.922	191	0.1%
0.904	191	0.1%
0.913	188	0.1%
0.911	186	0.1%
0.909	185	0.1%
0.899	185	0.1%
0.914	184	0.1%
Other values (5391)	122365	71.7%

Value	Count	Frequency (%)
0	46580	27.3%
1 × 10^-6	24	< 0.1%
1.01 × 10^-6	67	< 0.1%
1.02 × 10^-6	84	< 0.1%
1.03 × 10^-6	69	< 0.1%
1.04 × 10^-6	56	< 0.1%
1.05 × 10^-6	58	< 0.1%
1.06 × 10^-6	57	< 0.1%
1.07 × 10^-6	67	< 0.1%
1.08 × 10^-6	55	< 0.1%

Value	Count	Frequency (%)
1	10	< 0.1%
0.999	12	< 0.1%
0.998	9	< 0.1%
0.997	4	< 0.1%
0.996	6	< 0.1%
0.995	6	< 0.1%
0.994	8	< 0.1%
0.993	16	< 0.1%
0.992	11	< 0.1%
0.991	6	< 0.1%

key
Real number (ℝ)

Zeros

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.1998441

Minimum	0
Maximum	11
Zeros	21600
Zeros (%)	12.7%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.5150939
Coefficient of variation (CV)	0.67599986
Kurtosis	-1.2710487
Mean	5.1998441
Median Absolute Deviation (MAD)	3
Skewness	0.0058639886
Sum	887369
Variance	12.355885
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	21600	12.7%
7	20803	12.2%
2	18823	11.0%
9	17571	10.3%
5	16430	9.6%
4	12933	7.6%
1	12886	7.6%
10	12148	7.1%
8	10751	6.3%
11	10670	6.3%
Other values (2)	16038	9.4%

Value	Count	Frequency (%)
0	21600	12.7%
1	12886	7.6%
2	18823	11.0%
3	7297	4.3%
4	12933	7.6%
5	16430	9.6%
6	8741	5.1%
7	20803	12.2%
8	10751	6.3%
9	17571	10.3%

Value	Count	Frequency (%)
11	10670	6.3%
10	12148	7.1%
9	17571	10.3%
8	10751	6.3%
7	20803	12.2%
6	8741	5.1%
5	16430	9.6%
4	12933	7.6%
3	7297	4.3%
2	18823	11.0%

liveness
Real number (ℝ)

Distinct	1740
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.20583866

Minimum	0
Maximum	1
Zeros	12
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0599
Q1	0.0988
median	0.136
Q3	0.261
95-th percentile	0.61
Maximum	1
Range	1
Interquartile range (IQR)	0.1622

Descriptive statistics

Standard deviation	0.17480466
Coefficient of variation (CV)	0.84923146
Kurtosis	5.0012722
Mean	0.20583866
Median Absolute Deviation (MAD)	0.0532
Skewness	2.1543815
Sum	35126.984
Variance	0.03055667
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.111	1849	1.1%
0.11	1663	1.0%
0.109	1636	1.0%
0.108	1624	1.0%
0.107	1553	0.9%
0.106	1508	0.9%
0.112	1500	0.9%
0.105	1481	0.9%
0.103	1402	0.8%
0.114	1379	0.8%
Other values (1730)	155058	90.9%

Value	Count	Frequency (%)
0	12	< 0.1%
0.00967	1	< 0.1%
0.0101	1	< 0.1%
0.0103	1	< 0.1%
0.0116	1	< 0.1%
0.012	1	< 0.1%
0.0123	1	< 0.1%
0.0134	1	< 0.1%
0.0136	3	< 0.1%
0.0139	1	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.999	1	< 0.1%
0.998	2	< 0.1%
0.997	5	< 0.1%
0.996	3	< 0.1%
0.995	10	< 0.1%
0.994	8	< 0.1%
0.993	5	< 0.1%
0.992	13	< 0.1%
0.991	16	< 0.1%

loudness
Real number (ℝ)

High correlation

Distinct	25410
Distinct (%)	14.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-11.46799

Minimum	-60
Maximum	3.855
Zeros	0
Zeros (%)	0.0%
Negative	170622
Negative (%)	> 99.9%
Memory size	1.3 MiB

Quantile statistics

Minimum	-60
5-th percentile	-22.02
Q1	-14.615
median	-10.58
Q3	-7.183
95-th percentile	-4.1306
Maximum	3.855
Range	63.855
Interquartile range (IQR)	7.432

Descriptive statistics

Standard deviation	5.6979429
Coefficient of variation (CV)	-0.49685628
Kurtosis	1.8468035
Mean	-11.46799
Median Absolute Deviation (MAD)	3.648
Skewness	-1.0518411
Sum	-1957046.9
Variance	32.466553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-7.436	27	< 0.1%
-6.942	27	< 0.1%
-8.32	26	< 0.1%
-6.664	26	< 0.1%
-11.815	25	< 0.1%
-7.566	25	< 0.1%
-7.632	25	< 0.1%
-8.992	25	< 0.1%
-6.519	24	< 0.1%
-11.451	24	< 0.1%
Other values (25400)	170399	99.9%

Value	Count	Frequency (%)
-60	9	< 0.1%
-55	1	< 0.1%
-54.837	1	< 0.1%
-54.376	1	< 0.1%
-52.22	1	< 0.1%
-51.123	1	< 0.1%
-51.08	1	< 0.1%
-50.174	1	< 0.1%
-48.587	1	< 0.1%
-48.278	2	< 0.1%

Value	Count	Frequency (%)
3.855	1	< 0.1%
3.744	1	< 0.1%
2.799	1	< 0.1%
1.963	1	< 0.1%
1.83	1	< 0.1%
1.483	1	< 0.1%
1.342	1	< 0.1%
1.275	1	< 0.1%
1.073	1	< 0.1%
1.023	1	< 0.1%

mode
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	120635
0	50018

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	170653
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

Most occurring characters

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	170653	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	170653	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	170653	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

name
Text

Distinct	133638
Distinct (%)	78.3%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Length

Max length	203
Median length	170
Mean length	23.649329
Min length	1

Characters and Unicode

Total characters	4035829
Distinct characters	1621
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	114535 ?
Unique (%)	67.1%

Sample

1st row	Piano Concerto No. 3 in D Minor, Op. 30: III. Finale. Alla breve
2nd row	Clancy Lowered the Boom
3rd row	Gati Bali
4th row	Danny Boy
5th row	When Irish Eyes Are Smiling

Value	Count	Frequency (%)
	38799	5.1%
the	22353	2.9%
in	11337	1.5%
you	9284	1.2%
i	9264	1.2%
a	8989	1.2%
of	7726	1.0%
me	6916	0.9%
no	6735	0.9%
to	6086	0.8%
Other values (60263)	631900	83.2%

Most occurring characters

Value	Count	Frequency (%)
	588736	14.6%
e	348722	8.6%
a	250147	6.2%
o	234774	5.8%
n	193853	4.8%
i	193188	4.8%
r	178505	4.4%
t	170904	4.2%
s	125579	3.1%
l	120734	3.0%
Other values (1611)	1630687	40.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4035829	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	588736	14.6%
e	348722	8.6%
a	250147	6.2%
o	234774	5.8%
n	193853	4.8%
i	193188	4.8%
r	178505	4.4%
t	170904	4.2%
s	125579	3.1%
l	120734	3.0%
Other values (1611)	1630687	40.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4035829	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	588736	14.6%
e	348722	8.6%
a	250147	6.2%
o	234774	5.8%
n	193853	4.8%
i	193188	4.8%
r	178505	4.4%
t	170904	4.2%
s	125579	3.1%
l	120734	3.0%
Other values (1611)	1630687	40.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4035829	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	588736	14.6%
e	348722	8.6%
a	250147	6.2%
o	234774	5.8%
n	193853	4.8%
i	193188	4.8%
r	178505	4.4%
t	170904	4.2%
s	125579	3.1%
l	120734	3.0%
Other values (1611)	1630687	40.4%

popularity
Real number (ℝ)

High correlation Zeros

Distinct	100
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.431794

Minimum	0
Maximum	100
Zeros	27892
Zeros (%)	16.3%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	11
median	33
Q3	48
95-th percentile	66
Maximum	100
Range	100
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	21.826615
Coefficient of variation (CV)	0.694412
Kurtosis	-1.025591
Mean	31.431794
Median Absolute Deviation (MAD)	17
Skewness	-0.003733875
Sum	5363930
Variance	476.40113
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	27892	16.3%
43	3136	1.8%
44	3117	1.8%
41	3078	1.8%
42	3051	1.8%
40	3051	1.8%
39	2968	1.7%
36	2896	1.7%
46	2883	1.7%
1	2876	1.7%
Other values (90)	115705	67.8%

Value	Count	Frequency (%)
0	27892	16.3%
1	2876	1.7%
2	1733	1.0%
3	1467	0.9%
4	1114	0.7%
5	1018	0.6%
6	1017	0.6%
7	1116	0.7%
8	1128	0.7%
9	1213	0.7%

Value	Count	Frequency (%)
100	1	< 0.1%
99	1	< 0.1%
97	1	< 0.1%
96	4	< 0.1%
95	4	< 0.1%
94	4	< 0.1%
93	4	< 0.1%
92	11	< 0.1%
91	9	< 0.1%
90	11	< 0.1%

release_date
Date

Distinct	10968
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Minimum	1921-01-01 00:00:00
Maximum	2020-11-24 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

speechiness
Real number (ℝ)

Distinct	1626
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.098393262

Minimum	0
Maximum	0.97
Zeros	143
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0281
Q1	0.0349
median	0.045
Q3	0.0756
95-th percentile	0.354
Maximum	0.97
Range	0.97
Interquartile range (IQR)	0.0407

Descriptive statistics

Standard deviation	0.16274007
Coefficient of variation (CV)	1.6539758
Kurtosis	17.000433
Mean	0.098393262
Median Absolute Deviation (MAD)	0.0131
Skewness	4.0478485
Sum	16791.105
Variance	0.026484331
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0347	580	0.3%
0.0334	571	0.3%
0.0328	563	0.3%
0.0337	561	0.3%
0.033	559	0.3%
0.0349	557	0.3%
0.0332	557	0.3%
0.0362	553	0.3%
0.0363	553	0.3%
0.0344	552	0.3%
Other values (1616)	165047	96.7%

Value	Count	Frequency (%)
0	143	0.1%
0.0222	1	< 0.1%
0.0223	3	< 0.1%
0.0224	5	< 0.1%
0.0225	4	< 0.1%
0.0226	5	< 0.1%
0.0227	7	< 0.1%
0.0228	9	< 0.1%
0.0229	7	< 0.1%
0.023	9	< 0.1%

Value	Count	Frequency (%)
0.97	1	< 0.1%
0.969	3	< 0.1%
0.968	5	< 0.1%
0.967	12	< 0.1%
0.966	27	< 0.1%
0.965	34	< 0.1%
0.964	56	< 0.1%
0.963	73	< 0.1%
0.962	81	< 0.1%
0.961	106	0.1%

tempo
Real number (ℝ)

Distinct	84694
Distinct (%)	49.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.86159

Minimum	0
Maximum	243.507
Zeros	143
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	74.1516
Q1	93.421
median	114.729
Q3	135.537
95-th percentile	174.3738
Maximum	243.507
Range	243.507
Interquartile range (IQR)	42.116

Descriptive statistics

Standard deviation	30.708533
Coefficient of variation (CV)	0.26277696
Kurtosis	-0.077953213
Mean	116.86159
Median Absolute Deviation (MAD)	21.091
Skewness	0.44974062
Sum	19942781
Variance	943.014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	143	0.1%
120	20	< 0.1%
120.012	20	< 0.1%
128.005	19	< 0.1%
94.997	19	< 0.1%
120.011	18	< 0.1%
119.994	17	< 0.1%
119.993	16	< 0.1%
119.969	16	< 0.1%
129.995	16	< 0.1%
Other values (84684)	170349	99.8%

Value	Count	Frequency (%)
0	143	0.1%
30.946	1	< 0.1%
31.988	1	< 0.1%
32.466	1	< 0.1%
32.8	1	< 0.1%
32.941	1	< 0.1%
33.334	1	< 0.1%
33.391	1	< 0.1%
33.944	1	< 0.1%
34.496	1	< 0.1%

Value	Count	Frequency (%)
243.507	1	< 0.1%
243.372	1	< 0.1%
238.895	1	< 0.1%
236.799	1	< 0.1%
224.437	1	< 0.1%
222.605	1	< 0.1%
221.741	1	< 0.1%
221.112	1	< 0.1%
221.058	2	< 0.1%
220.229	1	< 0.1%

	acousticness	danceability	duration_ms	energy	explicit	instrumentalness	key	liveness	loudness	mode	popularity	speechiness	tempo	valence	year
acousticness	1.000	-0.230	-0.233	-0.759	0.249	0.292	-0.018	0.017	-0.600	0.061	-0.574	-0.055	-0.231	-0.158	-0.626
danceability	-0.230	1.000	-0.088	0.217	0.283	-0.281	0.023	-0.116	0.233	0.062	0.194	0.239	0.022	0.540	0.195
duration_ms	-0.233	-0.088	1.000	0.177	0.034	0.106	-0.003	-0.066	0.125	0.016	0.231	-0.094	0.013	-0.199	0.259
energy	-0.759	0.217	0.177	1.000	0.155	-0.221	0.027	0.067	0.814	0.048	0.487	0.124	0.263	0.359	0.537
explicit	0.249	0.283	0.034	0.155	1.000	0.147	0.096	0.067	0.197	0.079	0.262	0.468	0.078	0.112	0.340
instrumentalness	0.292	-0.281	0.106	-0.221	0.147	1.000	-0.012	-0.053	-0.339	0.038	-0.297	-0.101	-0.078	-0.167	-0.288
key	-0.018	0.023	-0.003	0.027	0.096	-0.012	1.000	-0.003	0.019	0.211	0.008	0.033	0.002	0.028	0.008
liveness	0.017	-0.116	-0.066	0.067	0.067	-0.053	-0.003	1.000	0.030	0.014	-0.114	0.112	-0.005	-0.010	-0.102
loudness	-0.600	0.233	0.125	0.814	0.197	-0.339	0.019	0.030	1.000	0.042	0.505	0.048	0.209	0.263	0.553
mode	0.061	0.062	0.016	0.048	0.079	0.038	0.211	0.014	0.042	1.000	0.057	0.076	0.016	0.039	0.072
popularity	-0.574	0.194	0.231	0.487	0.262	-0.297	0.008	-0.114	0.505	0.057	1.000	-0.090	0.138	0.006	0.863
speechiness	-0.055	0.239	-0.094	0.124	0.468	-0.101	0.033	0.112	0.048	0.076	-0.090	1.000	0.080	0.143	-0.048
tempo	-0.231	0.022	0.013	0.263	0.078	-0.078	0.002	-0.005	0.209	0.016	0.138	0.080	1.000	0.172	0.149
valence	-0.158	0.540	-0.199	0.359	0.112	-0.167	0.028	-0.010	0.263	0.039	0.006	0.143	0.172	1.000	-0.030
year	-0.626	0.195	0.259	0.537	0.340	-0.288	0.008	-0.102	0.553	0.072	0.863	-0.048	0.149	-0.030	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	valence	year	acousticness	artists	danceability	duration_ms	energy	id	instrumentalness	key	liveness	loudness	mode	name	popularity	release_date	speechiness	tempo
0	0.0594	1921	0.982	['Sergei Rachmaninoff', 'James Levine', 'Berliner Philharmoniker']	0.279	831667	0.211	4BJqT0PrAfrxzMOxytFOIz	0.878000	10	0.665	-20.096	1	Piano Concerto No. 3 in D Minor, Op. 30: III. Finale. Alla breve	4	1921	0.0366	80.954
1	0.9630	1921	0.732	['Dennis Day']	0.819	180533	0.341	7xPhfUan2yNtyFG0cUWkt8	0.000000	7	0.160	-12.441	1	Clancy Lowered the Boom	5	1921	0.4150	60.936
2	0.0394	1921	0.961	['KHP Kridhamardawa Karaton Ngayogyakarta Hadiningrat']	0.328	500062	0.166	1o6I8BglA6ylDMrIELygv1	0.913000	3	0.101	-14.850	1	Gati Bali	5	1921	0.0339	110.339
3	0.1650	1921	0.967	['Frank Parker']	0.275	210000	0.309	3ftBPsC5vPBKxYSee08FDH	0.000028	5	0.381	-9.316	1	Danny Boy	3	1921	0.0354	100.109
4	0.2530	1921	0.957	['Phil Regan']	0.418	166693	0.193	4d6HGyGT8e121BsdKmw9v6	0.000002	3	0.229	-10.096	1	When Irish Eyes Are Smiling	2	1921	0.0380	101.665
5	0.1960	1921	0.579	['KHP Kridhamardawa Karaton Ngayogyakarta Hadiningrat']	0.697	395076	0.346	4pyw9DVHGStUre4J6hPngr	0.168000	2	0.130	-12.506	1	Gati Mardika	6	1921	0.0700	119.824
6	0.4060	1921	0.996	['John McCormack']	0.518	159507	0.203	5uNZnElqOS3W4fRmRYPk4T	0.000000	0	0.115	-10.589	1	The Wearing of the Green	4	1921	0.0615	66.221
7	0.0731	1921	0.993	['Sergei Rachmaninoff']	0.389	218773	0.088	02GDntOXexBFUvSgaXLPkd	0.527000	1	0.363	-21.091	0	Morceaux de fantaisie, Op. 3: No. 2, Prélude in C-Sharp Minor. Lento	2	1921	0.0456	92.867
8	0.7210	1921	0.996	['Ignacio Corsini']	0.485	161520	0.130	05xDjWH9ub67nJJk82yfGf	0.151000	5	0.104	-21.508	0	La Mañanita - Remasterizado	0	1921-03-20	0.0483	64.678
9	0.7710	1921	0.982	['Fortugé']	0.684	196560	0.257	08zfJvRLp7pjAb94MA9JmF	0.000000	8	0.504	-16.415	1	Il Etait Syndiqué	0	1921	0.3990	109.378

	valence	year	acousticness	artists	danceability	duration_ms	energy	explicit	id	instrumentalness	key	liveness	loudness	mode	name	popularity	release_date	speechiness	tempo
170643	0.9070	2020	0.00952	['DJ Scheme', 'Cordae', 'Ski Mask The Slump God', 'Take A Daytrip']	0.917	228333	0.56900	1	3C9D1X8NkG2Ak1RaGpRnnQ	0.000000	7	0.0774	-10.456	1	Soda (feat. Take A Daytrip)	66	2020-11-13	0.2790	144.014
170644	0.4660	2020	0.31000	['Fleet Foxes']	0.562	253613	0.68600	0	308prODCCD0O660tIktbUi	0.022500	7	0.1250	-8.480	1	Sunblind	66	2020-09-22	0.0249	103.054
170645	0.1690	2020	0.99400	['Ólafur Arnalds']	0.281	190500	0.03330	0	13MOQ6oQqkrZEDkZOHukCw	0.959000	6	0.0995	-31.460	1	We Contain Multitudes (from home)	70	2020-08-26	0.0348	90.250
170646	0.5220	2020	0.20400	['Gunna']	0.598	230600	0.47200	1	2f8y4CuG57UJEmkG3ujd0D	0.000015	0	0.1080	-10.991	1	NASTY GIRL / ON CAMERA	66	2020-05-22	0.2580	120.080
170647	0.0838	2020	0.97400	['Najma Wallin']	0.175	133500	0.00759	0	6RuFOroO9VO0aMGEzirLHk	0.925000	7	0.1130	-35.072	1	Med slutna ögon	70	2020-02-21	0.0454	70.872
170648	0.6080	2020	0.08460	['Anuel AA', 'Daddy Yankee', 'KAROL G', 'Ozuna', 'J Balvin']	0.786	301714	0.80800	0	0KkIkfsLEJbrcIhYsCL7L5	0.000289	7	0.0822	-3.702	1	China	72	2020-05-29	0.0881	105.029
170649	0.7340	2020	0.20600	['Ashnikko']	0.717	150654	0.75300	0	0OStKKAuXlxA0fMH54Qs6E	0.000000	7	0.1010	-6.020	1	Halloweenie III: Seven Days	68	2020-10-23	0.0605	137.936
170650	0.6370	2020	0.10100	['MAMAMOO']	0.634	211280	0.85800	0	4BZXVFYCb76Q0Klojq4piV	0.000009	4	0.2580	-2.226	0	AYA	76	2020-11-03	0.0809	91.688
170651	0.1950	2020	0.00998	['Eminem']	0.671	337147	0.62300	1	5SiZJoLXp3WOl3J4C8IK0d	0.000008	2	0.6430	-7.161	1	Darkness	70	2020-01-17	0.3080	75.055
170652	0.6420	2020	0.13200	['KEVVO', 'J Balvin']	0.856	189507	0.72100	1	7HmnJHfs0BkFzX4x8j0hkl	0.004710	7	0.1820	-4.928	1	Billetes Azules (with J Balvin)	74	2020-10-16	0.1080	94.991

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample